//2014 data --added 10/20
//add fcounty for PA, 2012
// fips codes accessed here: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697

replace fcounty=1 if county==1 & year==2014
replace fcounty=3 if county==2 & year==2014
replace fcounty=5 if county==3 & year==2014
replace fcounty=7 if county==4 & year==2014
replace fcounty=9 if county==5 & year==2014
replace fcounty=11 if county==6 & year==2014
replace fcounty=13 if county==7 & year==2014
replace fcounty=15 if county==8 & year==2014
replace fcounty=17 if county==9 & year==2014
replace fcounty=19 if county==10 & year==2014
replace fcounty=21 if county==11 & year==2014
replace fcounty=23 if county==12 & year==2014
replace fcounty=25 if county==13 & year==2014
replace fcounty=27 if county==14 & year==2014
replace fcounty=29 if county==15 & year==2014
replace fcounty=31 if county==16 & year==2014
replace fcounty=33 if county==17 & year==2014
replace fcounty=35 if county==18 & year==2014
replace fcounty=37 if county==19 & year==2014
replace fcounty=39 if county==20 & year==2014
replace fcounty=41 if county==21 & year==2014
replace fcounty=43 if county==22 & year==2014
replace fcounty=45 if county==23 & year==2014
replace fcounty=47 if county==24 & year==2014
replace fcounty=49 if county==25 & year==2014
replace fcounty=51 if county==26 & year==2014
replace fcounty=53 if county==27 & year==2014
replace fcounty=55 if county==28 & year==2014
replace fcounty=57 if county==29 & year==2014
replace fcounty=59 if county==30 & year==2014
replace fcounty=61 if county==31 & year==2014
replace fcounty=63 if county==32 & year==2014
replace fcounty=65 if county==33 & year==2014
replace fcounty=67 if county==34 & year==2014
replace fcounty=69 if county==35 & year==2014
replace fcounty=71 if county==36 & year==2014
replace fcounty=73 if county==37 & year==2014
replace fcounty=75 if county==38 & year==2014
replace fcounty=77 if county==39 & year==2014
replace fcounty=79 if county==40 & year==2014
replace fcounty=81 if county==41 & year==2014
replace fcounty=83 if county==42 & year==2014
replace fcounty=85 if county==43 & year==2014
replace fcounty=87 if county==44 & year==2014
replace fcounty=89 if county==45 & year==2014
replace fcounty=91 if county==46 & year==2014
replace fcounty=93 if county==47 & year==2014
replace fcounty=95 if county==48 & year==2014
replace fcounty=97 if county==49 & year==2014
replace fcounty=99 if county==50 & year==2014
replace fcounty=101 if county==51 & year==2014
replace fcounty=103 if county==52 & year==2014
replace fcounty=105 if county==53 & year==2014
replace fcounty=107 if county==54 & year==2014
replace fcounty=109 if county==55 & year==2014
replace fcounty=111 if county==56 & year==2014
replace fcounty=113 if county==57 & year==2014
replace fcounty=115 if county==58 & year==2014
replace fcounty=117 if county==59 & year==2014
replace fcounty=119 if county==60 & year==2014
replace fcounty=121 if county==61 & year==2014
replace fcounty=123 if county==62 & year==2014
replace fcounty=125 if county==63 & year==2014
replace fcounty=127 if county==64 & year==2014
replace fcounty=129 if county==65 & year==2014
replace fcounty=131 if county==66 & year==2014
replace fcounty=133 if county==67 & year==2014

drop county
gen county=""

replace county="Adams" if fcounty==1 & year==2014
replace county="Allegheny" if fcounty==3 & year==2014
replace county="Armstrong" if fcounty==5 & year==2014
replace county="Beaver" if fcounty==7 & year==2014
replace county="Bedford" if fcounty==9 & year==2014
replace county="Berks" if fcounty==11 & year==2014
replace county="Blair" if fcounty==13 & year==2014
replace county="Bradford" if fcounty==15 & year==2014
replace county="Bucks" if fcounty==17 & year==2014
replace county="Butler" if fcounty==19 & year==2014
replace county="Cambria" if fcounty==21 & year==2014
replace county="Cameron" if fcounty==23 & year==2014
replace county="Carbon" if fcounty==25 & year==2014
replace county="Centre" if fcounty==27 & year==2014
replace county="Chester" if fcounty==29 & year==2014
replace county="Clarion" if fcounty==31 & year==2014
replace county="Clearfield" if fcounty==33 & year==2014
replace county="Clinton" if fcounty==35 & year==2014
replace county="Columbia" if fcounty==37 & year==2014
replace county="Crawford" if fcounty==39 & year==2014
replace county="Cumberland" if fcounty==41 & year==2014
replace county="Dauphin" if fcounty==43 & year==2014
replace county="Delaware" if fcounty==45 & year==2014
replace county="Elk" if fcounty==47 & year==2014
replace county="Erie" if fcounty==49 & year==2014
replace county="Fayette" if fcounty==51 & year==2014
replace county="Forest" if fcounty==53 & year==2014
replace county="Franklin" if fcounty==55 & year==2014
replace county="Fulton" if fcounty==57 & year==2014
replace county="Greene" if fcounty==59 & year==2014
replace county="Huntingdon" if fcounty==61 & year==2014
replace county="Indiana" if fcounty==63 & year==2014
replace county="Jefferson" if fcounty==65 & year==2014
replace county="Juniata" if fcounty==67 & year==2014
replace county="Lackawanna" if fcounty==69 & year==2014
replace county="Lancaster" if fcounty==71 & year==2014
replace county="Lawrence" if fcounty==73 & year==2014
replace county="Lebanon" if fcounty==75 & year==2014
replace county="Lehigh" if fcounty==77 & year==2014
replace county="Luzerne" if fcounty==79 & year==2014
replace county="Lycoming" if fcounty==81 & year==2014
replace county="McKean" if fcounty==83 & year==2014
replace county="Mercer" if fcounty==85 & year==2014
replace county="Mifflin" if fcounty==87 & year==2014
replace county="Monroe" if fcounty==89 & year==2014
replace county="Montgomery" if fcounty==91 & year==2014
replace county="Montour" if fcounty==93 & year==2014
replace county="Northampton" if fcounty==95 & year==2014
replace county="Northumberland" if fcounty==97 & year==2014
replace county="Perry" if fcounty==99 & year==2014
replace county="Philadelphia" if fcounty==101 & year==2014
replace county="Pike" if fcounty==103 & year==2014
replace county="Potter" if fcounty==105 & year==2014
replace county="Schuylkill" if fcounty==107 & year==2014
replace county="Snyder" if fcounty==109 & year==2014
replace county="Somerset" if fcounty==111 & year==2014
replace county="Sullivan" if fcounty==113 & year==2014
replace county="Susquehanna" if fcounty==115 & year==2014
replace county="Tioga" if fcounty==117 & year==2014
replace county="Union" if fcounty==119 & year==2014
replace county="Venango" if fcounty==121 & year==2014
replace county="Warren" if fcounty==123 & year==2014
replace county="Washington" if fcounty==125 & year==2014
replace county="Wayne" if fcounty==127 & year==2014
replace county="Westmoreland" if fcounty==129 & year==2014
replace county="Wyoming" if fcounty==131 & year==2014
replace county="York" if fcounty==133 & year==2014
